USE [NGroup_VTL_DB]
GO

/****** Object:  StoredProcedure [dbo].[GetAllGenericTypes]    Script Date: 5/30/2015 12:56:06 PM ******/
DROP PROCEDURE [dbo].[GetAllGenericTypes]
GO

/****** Object:  StoredProcedure [dbo].[GetAllGenericTypes]    Script Date: 5/30/2015 12:56:06 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

-- =============================================
-- Author:		Bui Thanh Nam
-- Create date: 20140104
-- Description:	get all types detail for web-app use
-- =============================================
CREATE PROCEDURE [dbo].[GetAllGenericTypes]
AS
BEGIN

	SET NOCOUNT ON;

    SELECT [ID]
      ,[Descriptions]
	  ,[Descriptions_En]
      ,[UniqueString]
      ,[SupTypeID]
      ,[CreatedAt]
      ,[CreatedBy]
      ,[LastUpdatedAt]
      ,[LastUpdatedBy]
      ,[IsActive]
      ,[CanEdit]
	  ,[MetaKeyword]
	  ,[MetaKeyword_En]
	  ,[MetaDescription]
	  ,[MetaDescription_En]
	FROM [dbo].[GenericTypes] WITH (NOLOCK)
	WHERE [IsActive] <> 0
END


GO


